Search results 60

  2. Search results
  3. There might be a bug when row starts below list of items in that column
Card image cap
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19
Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12
Card image cap
HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30
Card image cap
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28
Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6
Card image cap
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13
Card image cap
LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31
Card image cap
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22
Card image cap
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16
Card image cap
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16
Card image cap
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26
Card image cap
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11